home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
rteusage.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
2KB
|
39 lines
/* RCSVER $Id: rteusage.sql,v 1.2 2000-01-25 16:38:19-06 randy Exp $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: rteusage.sql
* Date: 07/12/1999
* memo: Randy Wood
* Description: Create the rteusage table. This table contains parameters
* for the usage of routes/runs/trips.
* Changes:
************************************************************************* */
CREATE TABLE rteusage
(
useflag NUMBER(1), /* 1=use route/run as unique segment */
/* identifier */
/* 2=use run/trip as unique segment */
/* identifier */
dir1flag NUMBER(1), /* 1=dir1 is entered as a text field */
/* 2=dir1 is selected from the dir1list table */
dir2flag NUMBER(1), /* 1=dir2 is entered as a text field */
/* 2=dir2 is selected from the dir2list table */
rtegen NUMBER(1), /* 0=use all trips to generate the ROUTE.FBD file */
/* 1=use dir1list.useflag as selection criteria for */
/* ROUTE.FBC */
/* 2=use dir2list.useflag as selection criteria for */
/* ROUTE.FBC */
/* 3=use both dir1list and dir2list2 */
notinlist NUMBER(1), /* If rtegen != 0, this flag specifies how */
/* to handle directions that are not found */
/* in dir1list or dir2list: */
/* 0=do not use in ROUTE.FBC */
/* 1=use in ROUTE.FBC */
dir1name VARCHAR2(20), /* Label for the Direction 1 field */
dir2name VARCHAR2(20), /* Label for the Direction 2 field */
route_name VARCHAR2(10), /* Label for route */
run_name VARCHAR2(10), /* Label for run */
trip_name VARCHAR2(10) /* Label for trip */
);